﻿CREATE TABLE [flcr].[PORTFOLIO_TYPE] (
    [PORTFOLIO_TYPE_ID]    INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]           VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]           DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]        INT           NOT NULL,
    [AUDIT_MOD_USER]       VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]       DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]    INT           NOT NULL,
    [BUILTIN]              BIT           NOT NULL,
    [ACTIVE_FLG]           BIT           NOT NULL,
    [SORT_ORDER]           INT           NOT NULL,
    [PORTFOLIO_TYPE]       INT           NOT NULL,
    [PORTFOLIO_TYPE_NAME]  VARCHAR (100) NOT NULL,
    [PORTFOLIO_TYPE_DESC]  VARCHAR (250) NOT NULL,
    [PORTFOLIO_TYPE_GROUP] INT           NOT NULL,
    [PARENT_ID]            INT           NULL
);

